Microsoft Excel Level 2

Outcomes

Participants will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel 2000. Participants will learn how to represent data graphically and maintain and manage lists.
The combined content of the Excel 2000: Level 1 and Excel 2000: Level 2 courses satisfies the requirements for the Certified Microsoft Office User for Excel 2000 at the Proficient level.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Excel 2000 Level 1, or equivalent knowledge

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

Creating charts Creating a chart sheet Creating an embedded chart Comparing chart sheets with embedded charts Modifying charts Chart types Modifying embedded charts Adding and deleting chart items Moving and sizing chart items Formatting a chart Formatting chart text Formatting labels Formatting the chart Printing a chart sheet

Adding graphic objects Formatting graphic objects Using graphic objects to enhance worksheets and charts Sorting data Single-level sorting Multiple-level sorting Sorting options Design considerations Filtering data Filtering a list Custom criteria Multiple-condition criteria Managing a filtered list Appendix Querying data

Performance-based objectives

• Create charts that graphically represent worksheet data.
• Modify charts.
• Customize charts by applying formatting.
• Enhance worksheets and charts by using the drawing tools to add graphic objects.
• Sort information in a list by using the Data, Sort command.
• Locate information quickly in a list that meets specified conditions by using the Advanced filter feature.